PX qref latch
Short Description
Each parallel execution process has a parallel execution qref latch, which needs to be acquired before the queue buffers can be manipulated.
Detailed Description​
Each parallel execution process has a parallel execution qref latch, which needs to be acquired before the queue buffers can be manipulated. High waits can be due to CPU starvation or query slaves are producing more data than can be consumed.
How to reduce this wait​
Refer to My Oracle Support for the "Master Note for Parallel Execution Wait Events".
Additional Links​
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.